Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 502749 |
| Missing cells | 2607548 |
| Missing cells (%) | 16.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 118.9 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Text | 6 |
CANCELLED is highly imbalanced (87.0%) | Imbalance |
DIVERTED is highly imbalanced (98.0%) | Imbalance |
DEP_TIME has 8815 (1.8%) missing values | Missing |
DEP_DELAY has 8815 (1.8%) missing values | Missing |
TAXI_OUT has 8938 (1.8%) missing values | Missing |
TAXI_IN has 9173 (1.8%) missing values | Missing |
ARR_TIME has 9173 (1.8%) missing values | Missing |
ARR_DELAY has 10002 (2.0%) missing values | Missing |
CANCELLATION_CODE has 493730 (98.2%) missing values | Missing |
AIR_TIME has 10002 (2.0%) missing values | Missing |
CARRIER_DELAY has 409780 (81.5%) missing values | Missing |
WEATHER_DELAY has 409780 (81.5%) missing values | Missing |
NAS_DELAY has 409780 (81.5%) missing values | Missing |
SECURITY_DELAY has 409780 (81.5%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 409780 (81.5%) missing values | Missing |
WEATHER_DELAY is highly skewed (γ1 = 21.7330739) | Skewed |
SECURITY_DELAY is highly skewed (γ1 = 154.3624039) | Skewed |
DEP_DELAY has 22838 (4.5%) zeros | Zeros |
ARR_DELAY has 9023 (1.8%) zeros | Zeros |
CARRIER_DELAY has 40359 (8.0%) zeros | Zeros |
WEATHER_DELAY has 88146 (17.5%) zeros | Zeros |
NAS_DELAY has 47985 (9.5%) zeros | Zeros |
SECURITY_DELAY has 92531 (18.4%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 49855 (9.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 05:56:58.637813 |
|---|---|
| Analysis finished | 2024-03-30 05:59:44.171246 |
| Duration | 2 minutes and 45.53 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9670153 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9989356 |
|---|---|
| Coefficient of variation (CV) | 0.50388904 |
| Kurtosis | -1.2281979 |
| Mean | 3.9670153 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.019561677 |
| Sum | 1994413 |
| Variance | 3.9957434 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 5 | 75323 | |
| 4 | 74952 | |
| 1 | 74941 | |
| 7 | 72282 | |
| 3 | 70645 | |
| 2 | 70624 | |
| 6 | 63982 |
| Value | Count | Frequency (%) |
| 1 | 74941 | |
| 2 | 70624 | |
| 3 | 70645 | |
| 4 | 74952 | |
| 5 | 75323 | |
| 6 | 63982 | |
| 7 | 72282 |
| Value | Count | Frequency (%) |
| 7 | 72282 | |
| 6 | 63982 | |
| 5 | 75323 | |
| 4 | 74952 | |
| 3 | 70645 | |
| 2 | 70624 | |
| 1 | 74941 |
FL_DATE
Date
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
| Minimum | 2023-02-01 00:00:00 |
|---|---|
| Maximum | 2023-02-28 00:00:00 |
Histogram with fixed size bins (bins=28)
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
| WN | |
|---|---|
| AA | |
| DL | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1005498 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 101455 | |
| AA | 71289 | |
| DL | 69152 | |
| UA | 53408 | |
| OO | 50486 | |
| YX | 23728 | 4.7% |
| B6 | 22186 | 4.4% |
| NK | 20192 | 4.0% |
| AS | 17913 | 3.6% |
| MQ | 17228 | 3.4% |
| Other values (5) | 55712 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 101455 | |
| aa | 71289 | |
| dl | 69152 | |
| ua | 53408 | |
| oo | 50486 | |
| yx | 23728 | 4.7% |
| b6 | 22186 | 4.4% |
| nk | 20192 | 4.0% |
| as | 17913 | 3.6% |
| mq | 17228 | 3.4% |
| Other values (5) | 55712 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 219896 | |
| N | 121647 | |
| O | 115022 | |
| W | 101455 | |
| D | 69152 | 6.9% |
| L | 69152 | 6.9% |
| U | 53408 | 5.3% |
| 9 | 27157 | 2.7% |
| Y | 23728 | 2.4% |
| X | 23728 | 2.4% |
| Other values (11) | 181153 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1005498 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 219896 | |
| N | 121647 | |
| O | 115022 | |
| W | 101455 | |
| D | 69152 | 6.9% |
| L | 69152 | 6.9% |
| U | 53408 | 5.3% |
| 9 | 27157 | 2.7% |
| Y | 23728 | 2.4% |
| X | 23728 | 2.4% |
| Other values (11) | 181153 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1005498 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 219896 | |
| N | 121647 | |
| O | 115022 | |
| W | 101455 | |
| D | 69152 | 6.9% |
| L | 69152 | 6.9% |
| U | 53408 | 5.3% |
| 9 | 27157 | 2.7% |
| Y | 23728 | 2.4% |
| X | 23728 | 2.4% |
| Other values (11) | 181153 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1005498 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 219896 | |
| N | 121647 | |
| O | 115022 | |
| W | 101455 | |
| D | 69152 | 6.9% |
| L | 69152 | 6.9% |
| U | 53408 | 5.3% |
| 9 | 27157 | 2.7% |
| Y | 23728 | 2.4% |
| X | 23728 | 2.4% |
| Other values (11) | 181153 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5819 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2213.2226 |
| Minimum | 1 |
|---|---|
| Maximum | 8816 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 272 |
| Q1 | 983 |
| median | 1922 |
| Q3 | 3062 |
| 95-th percentile | 5355 |
| Maximum | 8816 |
| Range | 8815 |
| Interquartile range (IQR) | 2079 |
Descriptive statistics
| Standard deviation | 1559.1208 |
|---|---|
| Coefficient of variation (CV) | 0.7044573 |
| Kurtosis | -0.40677493 |
| Mean | 2213.2226 |
| Median Absolute Deviation (MAD) | 1020 |
| Skewness | 0.72606599 |
| Sum | 1.1126954 × 109 |
| Variance | 2430857.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 710 | 300 | 0.1% |
| 1370 | 281 | 0.1% |
| 568 | 280 | 0.1% |
| 531 | 277 | 0.1% |
| 366 | 277 | 0.1% |
| 1168 | 276 | 0.1% |
| 2005 | 275 | 0.1% |
| 2274 | 273 | 0.1% |
| 1318 | 267 | 0.1% |
| 334 | 266 | 0.1% |
| Other values (5809) | 499977 |
| Value | Count | Frequency (%) |
| 1 | 120 | |
| 2 | 159 | |
| 3 | 182 | |
| 4 | 194 | |
| 5 | 68 | < 0.1% |
| 6 | 92 | |
| 7 | 103 | |
| 8 | 101 | |
| 9 | 80 | |
| 10 | 161 |
| Value | Count | Frequency (%) |
| 8816 | 1 | < 0.1% |
| 8815 | 1 | < 0.1% |
| 8814 | 4 | |
| 8813 | 3 | |
| 8812 | 1 | < 0.1% |
| 8809 | 1 | < 0.1% |
| 8808 | 2 | |
| 8807 | 2 | |
| 8806 | 1 | < 0.1% |
| 8803 | 1 | < 0.1% |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12651.492 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1522.1633 |
|---|---|
| Coefficient of variation (CV) | 0.12031492 |
| Kurtosis | -1.2890411 |
| Mean | 12651.492 |
| Median Absolute Deviation (MAD) | 1568 |
| Skewness | 0.10429836 |
| Sum | 6.3605249 × 109 |
| Variance | 2316981.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 24126 | 4.8% |
| 11292 | 20653 | 4.1% |
| 11298 | 19910 | 4.0% |
| 13930 | 19329 | 3.8% |
| 11057 | 14234 | 2.8% |
| 12889 | 14116 | 2.8% |
| 12892 | 13973 | 2.8% |
| 14107 | 13700 | 2.7% |
| 12953 | 13203 | 2.6% |
| 13204 | 12400 | 2.5% |
| Other values (329) | 337105 |
| Value | Count | Frequency (%) |
| 10135 | 288 | 0.1% |
| 10136 | 80 | < 0.1% |
| 10140 | 1559 | |
| 10141 | 55 | < 0.1% |
| 10146 | 68 | < 0.1% |
| 10155 | 81 | < 0.1% |
| 10157 | 136 | < 0.1% |
| 10158 | 217 | < 0.1% |
| 10165 | 8 | < 0.1% |
| 10170 | 48 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 123 | < 0.1% |
| 16218 | 136 | < 0.1% |
| 15991 | 56 | < 0.1% |
| 15919 | 777 | |
| 15841 | 56 | < 0.1% |
| 15624 | 496 | |
| 15607 | 68 | < 0.1% |
| 15582 | 48 | < 0.1% |
| 15569 | 48 | < 0.1% |
| 15412 | 897 |
ORIGIN
Text
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1508247 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | DTW |
| 3rd row | GRB |
| 4th row | ATL |
| 5th row | FAY |
| Value | Count | Frequency (%) |
| atl | 24126 | 4.8% |
| den | 20653 | 4.1% |
| dfw | 19910 | 4.0% |
| ord | 19329 | 3.8% |
| clt | 14234 | 2.8% |
| las | 14116 | 2.8% |
| lax | 13973 | 2.8% |
| phx | 13700 | 2.7% |
| lga | 13203 | 2.6% |
| mco | 12400 | 2.5% |
| Other values (329) | 337105 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 172302 | 11.4% |
| L | 139636 | 9.3% |
| S | 128183 | 8.5% |
| D | 117109 | 7.8% |
| T | 78596 | 5.2% |
| O | 77395 | 5.1% |
| C | 75973 | 5.0% |
| M | 66645 | 4.4% |
| F | 62080 | 4.1% |
| W | 58604 | 3.9% |
| Other values (16) | 531724 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 172302 | 11.4% |
| L | 139636 | 9.3% |
| S | 128183 | 8.5% |
| D | 117109 | 7.8% |
| T | 78596 | 5.2% |
| O | 77395 | 5.1% |
| C | 75973 | 5.0% |
| M | 66645 | 4.4% |
| F | 62080 | 4.1% |
| W | 58604 | 3.9% |
| Other values (16) | 531724 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 172302 | 11.4% |
| L | 139636 | 9.3% |
| S | 128183 | 8.5% |
| D | 117109 | 7.8% |
| T | 78596 | 5.2% |
| O | 77395 | 5.1% |
| C | 75973 | 5.0% |
| M | 66645 | 4.4% |
| F | 62080 | 4.1% |
| W | 58604 | 3.9% |
| Other values (16) | 531724 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 172302 | 11.4% |
| L | 139636 | 9.3% |
| S | 128183 | 8.5% |
| D | 117109 | 7.8% |
| T | 78596 | 5.2% |
| O | 77395 | 5.1% |
| C | 75973 | 5.0% |
| M | 66645 | 4.4% |
| F | 62080 | 4.1% |
| W | 58604 | 3.9% |
| Other values (16) | 531724 |
ORIGIN_CITY_NAME
Text
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.027043 |
| Min length | 8 |
Characters and Unicode
| Total characters | 6549333 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | Detroit, MI |
| 3rd row | Green Bay, WI |
| 4th row | Atlanta, GA |
| 5th row | Fayetteville, NC |
| Value | Count | Frequency (%) |
| ca | 53600 | 4.6% |
| tx | 51571 | 4.4% |
| fl | 47508 | 4.0% |
| ny | 29961 | 2.6% |
| new | 27756 | 2.4% |
| il | 26141 | 2.2% |
| ga | 25880 | 2.2% |
| san | 25419 | 2.2% |
| chicago | 25179 | 2.1% |
| atlanta | 24126 | 2.1% |
| Other values (404) | 837434 |
Most occurring characters
| Value | Count | Frequency (%) |
| 671826 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498054 | 7.6% |
| o | 361670 | 5.5% |
| e | 346506 | 5.3% |
| n | 319899 | 4.9% |
| t | 309295 | 4.7% |
| l | 282248 | 4.3% |
| i | 245001 | 3.7% |
| r | 239475 | 3.7% |
| Other values (46) | 2772610 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6549333 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 671826 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498054 | 7.6% |
| o | 361670 | 5.5% |
| e | 346506 | 5.3% |
| n | 319899 | 4.9% |
| t | 309295 | 4.7% |
| l | 282248 | 4.3% |
| i | 245001 | 3.7% |
| r | 239475 | 3.7% |
| Other values (46) | 2772610 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6549333 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 671826 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498054 | 7.6% |
| o | 361670 | 5.5% |
| e | 346506 | 5.3% |
| n | 319899 | 4.9% |
| t | 309295 | 4.7% |
| l | 282248 | 4.3% |
| i | 245001 | 3.7% |
| r | 239475 | 3.7% |
| Other values (46) | 2772610 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6549333 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 671826 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498054 | 7.6% |
| o | 361670 | 5.5% |
| e | 346506 | 5.3% |
| n | 319899 | 4.9% |
| t | 309295 | 4.7% |
| l | 282248 | 4.3% |
| i | 245001 | 3.7% |
| r | 239475 | 3.7% |
| Other values (46) | 2772610 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1390475 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4091898 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | Michigan |
| 3rd row | Wisconsin |
| 4th row | Georgia |
| 5th row | North Carolina |
| Value | Count | Frequency (%) |
| california | 53600 | 9.3% |
| texas | 51571 | 8.9% |
| florida | 47508 | 8.2% |
| new | 43553 | 7.5% |
| york | 29961 | 5.2% |
| illinois | 26141 | 4.5% |
| georgia | 25880 | 4.5% |
| carolina | 24222 | 4.2% |
| colorado | 24087 | 4.2% |
| north | 21805 | 3.8% |
| Other values (51) | 229998 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 546066 | |
| i | 459458 | 11.2% |
| o | 394927 | 9.7% |
| r | 300894 | 7.4% |
| n | 295883 | 7.2% |
| e | 252291 | 6.2% |
| s | 230151 | 5.6% |
| l | 227643 | 5.6% |
| C | 103676 | 2.5% |
| d | 103038 | 2.5% |
| Other values (37) | 1177871 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4091898 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 546066 | |
| i | 459458 | 11.2% |
| o | 394927 | 9.7% |
| r | 300894 | 7.4% |
| n | 295883 | 7.2% |
| e | 252291 | 6.2% |
| s | 230151 | 5.6% |
| l | 227643 | 5.6% |
| C | 103676 | 2.5% |
| d | 103038 | 2.5% |
| Other values (37) | 1177871 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4091898 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 546066 | |
| i | 459458 | 11.2% |
| o | 394927 | 9.7% |
| r | 300894 | 7.4% |
| n | 295883 | 7.2% |
| e | 252291 | 6.2% |
| s | 230151 | 5.6% |
| l | 227643 | 5.6% |
| C | 103676 | 2.5% |
| d | 103038 | 2.5% |
| Other values (37) | 1177871 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4091898 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 546066 | |
| i | 459458 | 11.2% |
| o | 394927 | 9.7% |
| r | 300894 | 7.4% |
| n | 295883 | 7.2% |
| e | 252291 | 6.2% |
| s | 230151 | 5.6% |
| l | 227643 | 5.6% |
| C | 103676 | 2.5% |
| d | 103038 | 2.5% |
| Other values (37) | 1177871 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.229265 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 49 |
Descriptive statistics
| Standard deviation | 26.848321 |
|---|---|
| Coefficient of variation (CV) | 0.49508916 |
| Kurtosis | -1.3323253 |
| Mean | 54.229265 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | -0.011996634 |
| Sum | 27263709 |
| Variance | 720.83236 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 53600 | 10.7% |
| 74 | 51571 | 10.3% |
| 33 | 47508 | 9.4% |
| 22 | 29961 | 6.0% |
| 41 | 26141 | 5.2% |
| 34 | 25880 | 5.1% |
| 82 | 24087 | 4.8% |
| 36 | 20495 | 4.1% |
| 38 | 17703 | 3.5% |
| 81 | 15839 | 3.2% |
| Other values (42) | 189964 |
| Value | Count | Frequency (%) |
| 1 | 2437 | 0.5% |
| 2 | 9894 | |
| 3 | 2598 | 0.5% |
| 4 | 549 | 0.1% |
| 5 | 92 | < 0.1% |
| 11 | 1767 | 0.4% |
| 12 | 958 | 0.2% |
| 13 | 10730 | |
| 14 | 460 | 0.1% |
| 15 | 1164 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 12745 | 2.5% |
| 92 | 5535 | 1.1% |
| 91 | 53600 | |
| 88 | 889 | 0.2% |
| 87 | 8580 | 1.7% |
| 86 | 1781 | 0.4% |
| 85 | 15612 | 3.1% |
| 84 | 1859 | 0.4% |
| 83 | 2144 | 0.4% |
| 82 | 24087 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12651.428 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1522.2048 |
|---|---|
| Coefficient of variation (CV) | 0.12031882 |
| Kurtosis | -1.2891095 |
| Mean | 12651.428 |
| Median Absolute Deviation (MAD) | 1574 |
| Skewness | 0.10437554 |
| Sum | 6.3604926 × 109 |
| Variance | 2317107.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 24119 | 4.8% |
| 11292 | 20651 | 4.1% |
| 11298 | 19900 | 4.0% |
| 13930 | 19321 | 3.8% |
| 11057 | 14246 | 2.8% |
| 12889 | 14106 | 2.8% |
| 12892 | 13961 | 2.8% |
| 14107 | 13697 | 2.7% |
| 12953 | 13200 | 2.6% |
| 13204 | 12403 | 2.5% |
| Other values (329) | 337145 |
| Value | Count | Frequency (%) |
| 10135 | 289 | 0.1% |
| 10136 | 79 | < 0.1% |
| 10140 | 1559 | |
| 10141 | 55 | < 0.1% |
| 10146 | 68 | < 0.1% |
| 10155 | 81 | < 0.1% |
| 10157 | 136 | < 0.1% |
| 10158 | 217 | < 0.1% |
| 10165 | 8 | < 0.1% |
| 10170 | 48 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 123 | < 0.1% |
| 16218 | 136 | < 0.1% |
| 15991 | 56 | < 0.1% |
| 15919 | 777 | |
| 15841 | 56 | < 0.1% |
| 15624 | 496 | |
| 15607 | 68 | < 0.1% |
| 15582 | 48 | < 0.1% |
| 15569 | 48 | < 0.1% |
| 15412 | 898 |
DEST
Text
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1508247 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BGM |
|---|---|
| 2nd row | GRB |
| 3rd row | DTW |
| 4th row | FAY |
| 5th row | ATL |
| Value | Count | Frequency (%) |
| atl | 24119 | 4.8% |
| den | 20651 | 4.1% |
| dfw | 19900 | 4.0% |
| ord | 19321 | 3.8% |
| clt | 14246 | 2.8% |
| las | 14106 | 2.8% |
| lax | 13961 | 2.8% |
| phx | 13697 | 2.7% |
| lga | 13200 | 2.6% |
| mco | 12403 | 2.5% |
| Other values (329) | 337145 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 172274 | 11.4% |
| L | 139635 | 9.3% |
| S | 128176 | 8.5% |
| D | 117098 | 7.8% |
| T | 78606 | 5.2% |
| O | 77380 | 5.1% |
| C | 76000 | 5.0% |
| M | 66657 | 4.4% |
| F | 62074 | 4.1% |
| W | 58597 | 3.9% |
| Other values (16) | 531750 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 172274 | 11.4% |
| L | 139635 | 9.3% |
| S | 128176 | 8.5% |
| D | 117098 | 7.8% |
| T | 78606 | 5.2% |
| O | 77380 | 5.1% |
| C | 76000 | 5.0% |
| M | 66657 | 4.4% |
| F | 62074 | 4.1% |
| W | 58597 | 3.9% |
| Other values (16) | 531750 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 172274 | 11.4% |
| L | 139635 | 9.3% |
| S | 128176 | 8.5% |
| D | 117098 | 7.8% |
| T | 78606 | 5.2% |
| O | 77380 | 5.1% |
| C | 76000 | 5.0% |
| M | 66657 | 4.4% |
| F | 62074 | 4.1% |
| W | 58597 | 3.9% |
| Other values (16) | 531750 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 172274 | 11.4% |
| L | 139635 | 9.3% |
| S | 128176 | 8.5% |
| D | 117098 | 7.8% |
| T | 78606 | 5.2% |
| O | 77380 | 5.1% |
| C | 76000 | 5.0% |
| M | 66657 | 4.4% |
| F | 62074 | 4.1% |
| W | 58597 | 3.9% |
| Other values (16) | 531750 |
DEST_CITY_NAME
Text
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.027117 |
| Min length | 8 |
Characters and Unicode
| Total characters | 6549370 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Binghamton, NY |
|---|---|
| 2nd row | Green Bay, WI |
| 3rd row | Detroit, MI |
| 4th row | Fayetteville, NC |
| 5th row | Atlanta, GA |
| Value | Count | Frequency (%) |
| ca | 53578 | 4.6% |
| tx | 51562 | 4.4% |
| fl | 47524 | 4.0% |
| ny | 29961 | 2.6% |
| new | 27754 | 2.4% |
| il | 26133 | 2.2% |
| ga | 25875 | 2.2% |
| san | 25411 | 2.2% |
| chicago | 25171 | 2.1% |
| atlanta | 24119 | 2.1% |
| Other values (404) | 837473 |
Most occurring characters
| Value | Count | Frequency (%) |
| 671812 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498051 | 7.6% |
| o | 361647 | 5.5% |
| e | 346489 | 5.3% |
| n | 319913 | 4.9% |
| t | 309315 | 4.7% |
| l | 282255 | 4.3% |
| i | 245021 | 3.7% |
| r | 239495 | 3.7% |
| Other values (46) | 2772623 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6549370 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 671812 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498051 | 7.6% |
| o | 361647 | 5.5% |
| e | 346489 | 5.3% |
| n | 319913 | 4.9% |
| t | 309315 | 4.7% |
| l | 282255 | 4.3% |
| i | 245021 | 3.7% |
| r | 239495 | 3.7% |
| Other values (46) | 2772623 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6549370 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 671812 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498051 | 7.6% |
| o | 361647 | 5.5% |
| e | 346489 | 5.3% |
| n | 319913 | 4.9% |
| t | 309315 | 4.7% |
| l | 282255 | 4.3% |
| i | 245021 | 3.7% |
| r | 239495 | 3.7% |
| Other values (46) | 2772623 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6549370 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 671812 | 10.3% | |
| , | 502749 | 7.7% |
| a | 498051 | 7.6% |
| o | 361647 | 5.5% |
| e | 346489 | 5.3% |
| n | 319913 | 4.9% |
| t | 309315 | 4.7% |
| l | 282255 | 4.3% |
| i | 245021 | 3.7% |
| r | 239495 | 3.7% |
| Other values (46) | 2772623 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1391728 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4091961 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | Wisconsin |
| 3rd row | Michigan |
| 4th row | North Carolina |
| 5th row | Georgia |
| Value | Count | Frequency (%) |
| california | 53578 | 9.3% |
| texas | 51562 | 8.9% |
| florida | 47524 | 8.2% |
| new | 43549 | 7.5% |
| york | 29961 | 5.2% |
| illinois | 26133 | 4.5% |
| georgia | 25875 | 4.5% |
| carolina | 24237 | 4.2% |
| colorado | 24086 | 4.2% |
| north | 21820 | 3.8% |
| Other values (51) | 230015 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 546057 | |
| i | 459448 | 11.2% |
| o | 394946 | 9.7% |
| r | 300919 | 7.4% |
| n | 295883 | 7.2% |
| e | 252268 | 6.2% |
| s | 230143 | 5.6% |
| l | 227640 | 5.6% |
| C | 103669 | 2.5% |
| d | 103046 | 2.5% |
| Other values (37) | 1177942 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4091961 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 546057 | |
| i | 459448 | 11.2% |
| o | 394946 | 9.7% |
| r | 300919 | 7.4% |
| n | 295883 | 7.2% |
| e | 252268 | 6.2% |
| s | 230143 | 5.6% |
| l | 227640 | 5.6% |
| C | 103669 | 2.5% |
| d | 103046 | 2.5% |
| Other values (37) | 1177942 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4091961 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 546057 | |
| i | 459448 | 11.2% |
| o | 394946 | 9.7% |
| r | 300919 | 7.4% |
| n | 295883 | 7.2% |
| e | 252268 | 6.2% |
| s | 230143 | 5.6% |
| l | 227640 | 5.6% |
| C | 103669 | 2.5% |
| d | 103046 | 2.5% |
| Other values (37) | 1177942 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4091961 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 546057 | |
| i | 459448 | 11.2% |
| o | 394946 | 9.7% |
| r | 300919 | 7.4% |
| n | 295883 | 7.2% |
| e | 252268 | 6.2% |
| s | 230143 | 5.6% |
| l | 227640 | 5.6% |
| C | 103669 | 2.5% |
| d | 103046 | 2.5% |
| Other values (37) | 1177942 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.225516 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 49 |
Descriptive statistics
| Standard deviation | 26.847625 |
|---|---|
| Coefficient of variation (CV) | 0.49511054 |
| Kurtosis | -1.3322086 |
| Mean | 54.225516 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | -0.011797995 |
| Sum | 27261824 |
| Variance | 720.79495 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 53578 | 10.7% |
| 74 | 51562 | 10.3% |
| 33 | 47524 | 9.5% |
| 22 | 29961 | 6.0% |
| 41 | 26133 | 5.2% |
| 34 | 25875 | 5.1% |
| 82 | 24086 | 4.8% |
| 36 | 20510 | 4.1% |
| 38 | 17705 | 3.5% |
| 81 | 15835 | 3.1% |
| Other values (42) | 189980 |
| Value | Count | Frequency (%) |
| 1 | 2437 | 0.5% |
| 2 | 9895 | |
| 3 | 2601 | 0.5% |
| 4 | 549 | 0.1% |
| 5 | 92 | < 0.1% |
| 11 | 1768 | 0.4% |
| 12 | 959 | 0.2% |
| 13 | 10731 | |
| 14 | 459 | 0.1% |
| 15 | 1164 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 12742 | 2.5% |
| 92 | 5539 | 1.1% |
| 91 | 53578 | |
| 88 | 890 | 0.2% |
| 87 | 8581 | 1.7% |
| 86 | 1781 | 0.4% |
| 85 | 15602 | 3.1% |
| 84 | 1862 | 0.4% |
| 83 | 2143 | 0.4% |
| 82 | 24086 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1200 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1330.1873 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 910 |
| median | 1323 |
| Q3 | 1735 |
| 95-th percentile | 2125 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 825 |
Descriptive statistics
| Standard deviation | 491.88908 |
|---|---|
| Coefficient of variation (CV) | 0.36978933 |
| Kurtosis | -1.0693535 |
| Mean | 1330.1873 |
| Median Absolute Deviation (MAD) | 413 |
| Skewness | 0.07973849 |
| Sum | 6.6875036 × 108 |
| Variance | 241954.87 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 11770 | 2.3% |
| 700 | 8386 | 1.7% |
| 800 | 5304 | 1.1% |
| 900 | 3795 | 0.8% |
| 630 | 3414 | 0.7% |
| 730 | 3272 | 0.7% |
| 830 | 3135 | 0.6% |
| 1100 | 3086 | 0.6% |
| 1000 | 2986 | 0.6% |
| 615 | 2853 | 0.6% |
| Other values (1190) | 454748 |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 5 | 15 | |
| 6 | 3 | < 0.1% |
| 7 | 4 | < 0.1% |
| 9 | 5 | < 0.1% |
| 10 | 13 | |
| 12 | 3 | < 0.1% |
| 14 | 13 |
| Value | Count | Frequency (%) |
| 2359 | 891 | |
| 2358 | 29 | < 0.1% |
| 2357 | 28 | < 0.1% |
| 2356 | 30 | < 0.1% |
| 2355 | 240 | < 0.1% |
| 2354 | 52 | < 0.1% |
| 2353 | 60 | < 0.1% |
| 2352 | 29 | < 0.1% |
| 2351 | 5 | < 0.1% |
| 2350 | 224 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING
| Distinct | 1387 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 8815 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1333.7364 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 559 |
| Q1 | 913.25 |
| median | 1327 |
| Q3 | 1744 |
| 95-th percentile | 2135 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 830.75 |
Descriptive statistics
| Standard deviation | 503.5304 |
|---|---|
| Coefficient of variation (CV) | 0.37753367 |
| Kurtosis | -1.0084023 |
| Mean | 1333.7364 |
| Median Absolute Deviation (MAD) | 416 |
| Skewness | 0.029387337 |
| Sum | 6.5877777 × 108 |
| Variance | 253542.87 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 1470 | 0.3% |
| 556 | 1262 | 0.3% |
| 557 | 1232 | 0.2% |
| 554 | 1180 | 0.2% |
| 558 | 1117 | 0.2% |
| 559 | 1015 | 0.2% |
| 655 | 1013 | 0.2% |
| 553 | 1012 | 0.2% |
| 657 | 955 | 0.2% |
| 658 | 952 | 0.2% |
| Other values (1377) | 482726 | |
| (Missing) | 8815 | 1.8% |
| Value | Count | Frequency (%) |
| 1 | 58 | |
| 2 | 43 | |
| 3 | 50 | |
| 4 | 35 | |
| 5 | 51 | |
| 6 | 32 | |
| 7 | 47 | |
| 8 | 40 | |
| 9 | 43 | |
| 10 | 47 |
| Value | Count | Frequency (%) |
| 2400 | 38 | < 0.1% |
| 2359 | 67 | |
| 2358 | 79 | |
| 2357 | 64 | |
| 2356 | 91 | |
| 2355 | 83 | |
| 2354 | 99 | |
| 2353 | 97 | |
| 2352 | 90 | |
| 2351 | 90 |
DEP_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1095 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 8815 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.140636 |
| Minimum | -45 |
|---|---|
| Maximum | 2947 |
| Zeros | 22838 |
| Zeros (%) | 4.5% |
| Negative | 296848 |
| Negative (%) | 59.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | -45 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -2 |
| Q3 | 7 |
| 95-th percentile | 68 |
| Maximum | 2947 |
| Range | 2992 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 53.240752 |
|---|---|
| Coefficient of variation (CV) | 5.2502379 |
| Kurtosis | 308.15466 |
| Mean | 10.140636 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 13.416682 |
| Sum | 5008805 |
| Variance | 2834.5777 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 38556 | 7.7% |
| -4 | 35453 | 7.1% |
| -3 | 33699 | 6.7% |
| -6 | 30522 | 6.1% |
| -2 | 30410 | 6.0% |
| -1 | 27082 | 5.4% |
| -7 | 25733 | 5.1% |
| 0 | 22838 | 4.5% |
| -8 | 21120 | 4.2% |
| -9 | 16306 | 3.2% |
| Other values (1085) | 212215 |
| Value | Count | Frequency (%) |
| -45 | 2 | < 0.1% |
| -41 | 2 | < 0.1% |
| -38 | 1 | < 0.1% |
| -37 | 2 | < 0.1% |
| -35 | 2 | < 0.1% |
| -33 | 4 | < 0.1% |
| -32 | 2 | < 0.1% |
| -31 | 10 | |
| -30 | 9 | |
| -29 | 13 |
| Value | Count | Frequency (%) |
| 2947 | 1 | |
| 2827 | 1 | |
| 2705 | 1 | |
| 2414 | 1 | |
| 2304 | 1 | |
| 2235 | 1 | |
| 2226 | 1 | |
| 2220 | 1 | |
| 2065 | 1 | |
| 2046 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING
| Distinct | 161 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8938 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.554496 |
| Minimum | 1 |
|---|---|
| Maximum | 175 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 34 |
| Maximum | 175 |
| Range | 174 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 9.4447894 |
|---|---|
| Coefficient of variation (CV) | 0.53802682 |
| Kurtosis | 19.359897 |
| Mean | 17.554496 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.17693 |
| Sum | 8668603 |
| Variance | 89.204047 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12 | 39435 | 7.8% |
| 13 | 39281 | 7.8% |
| 14 | 37265 | 7.4% |
| 11 | 36766 | 7.3% |
| 15 | 33407 | 6.6% |
| 10 | 30264 | 6.0% |
| 16 | 30041 | 6.0% |
| 17 | 25910 | 5.2% |
| 18 | 22554 | 4.5% |
| 9 | 21210 | 4.2% |
| Other values (151) | 177678 |
| Value | Count | Frequency (%) |
| 1 | 5 | < 0.1% |
| 2 | 15 | < 0.1% |
| 3 | 42 | < 0.1% |
| 4 | 187 | < 0.1% |
| 5 | 607 | 0.1% |
| 6 | 2344 | 0.5% |
| 7 | 6351 | 1.3% |
| 8 | 12587 | |
| 9 | 21210 | |
| 10 | 30264 |
| Value | Count | Frequency (%) |
| 175 | 1 | < 0.1% |
| 172 | 1 | < 0.1% |
| 168 | 1 | < 0.1% |
| 167 | 1 | < 0.1% |
| 166 | 1 | < 0.1% |
| 163 | 1 | < 0.1% |
| 161 | 2 | |
| 158 | 1 | < 0.1% |
| 156 | 3 | |
| 155 | 1 | < 0.1% |
TAXI_IN
Real number (ℝ)
MISSING
| Distinct | 157 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9173 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.9077852 |
| Minimum | 1 |
|---|---|
| Maximum | 195 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 18 |
| Maximum | 195 |
| Range | 194 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.2718734 |
|---|---|
| Coefficient of variation (CV) | 0.79312643 |
| Kurtosis | 59.271668 |
| Mean | 7.9077852 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.0843466 |
| Sum | 3903093 |
| Variance | 39.336396 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 75127 | |
| 5 | 71456 | |
| 6 | 59218 | |
| 7 | 48410 | |
| 3 | 44412 | |
| 8 | 37385 | |
| 9 | 29180 | 5.8% |
| 10 | 22943 | 4.6% |
| 11 | 17608 | 3.5% |
| 12 | 13804 | 2.7% |
| Other values (147) | 74033 |
| Value | Count | Frequency (%) |
| 1 | 649 | 0.1% |
| 2 | 10557 | 2.1% |
| 3 | 44412 | |
| 4 | 75127 | |
| 5 | 71456 | |
| 6 | 59218 | |
| 7 | 48410 | |
| 8 | 37385 | |
| 9 | 29180 | 5.8% |
| 10 | 22943 | 4.6% |
| Value | Count | Frequency (%) |
| 195 | 1 | |
| 193 | 1 | |
| 185 | 2 | |
| 180 | 1 | |
| 175 | 1 | |
| 171 | 1 | |
| 170 | 1 | |
| 168 | 1 | |
| 167 | 2 | |
| 163 | 1 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1298 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1499.6937 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 728 |
| Q1 | 1109 |
| median | 1523 |
| Q3 | 1930 |
| 95-th percentile | 2300 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 821 |
Descriptive statistics
| Standard deviation | 516.47957 |
|---|---|
| Coefficient of variation (CV) | 0.34439004 |
| Kurtosis | -0.49893893 |
| Mean | 1499.6937 |
| Median Absolute Deviation (MAD) | 411 |
| Skewness | -0.27598216 |
| Sum | 7.539695 × 108 |
| Variance | 266751.14 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2359 | 2539 | 0.5% |
| 1810 | 1690 | 0.3% |
| 1915 | 1675 | 0.3% |
| 1025 | 1584 | 0.3% |
| 2000 | 1553 | 0.3% |
| 1710 | 1537 | 0.3% |
| 1000 | 1508 | 0.3% |
| 1750 | 1497 | 0.3% |
| 1530 | 1471 | 0.3% |
| 1640 | 1470 | 0.3% |
| Other values (1288) | 486225 |
| Value | Count | Frequency (%) |
| 1 | 36 | < 0.1% |
| 2 | 80 | < 0.1% |
| 3 | 96 | < 0.1% |
| 4 | 84 | < 0.1% |
| 5 | 523 | |
| 6 | 110 | < 0.1% |
| 7 | 98 | < 0.1% |
| 8 | 56 | < 0.1% |
| 9 | 126 | < 0.1% |
| 10 | 310 |
| Value | Count | Frequency (%) |
| 2359 | 2539 | |
| 2358 | 524 | 0.1% |
| 2357 | 808 | 0.2% |
| 2356 | 544 | 0.1% |
| 2355 | 906 | 0.2% |
| 2354 | 505 | 0.1% |
| 2353 | 413 | 0.1% |
| 2352 | 295 | 0.1% |
| 2351 | 249 | < 0.1% |
| 2350 | 629 | 0.1% |
ARR_TIME
Real number (ℝ)
MISSING
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 9173 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1476.3177 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 659 |
| Q1 | 1054 |
| median | 1513 |
| Q3 | 1923 |
| 95-th percentile | 2255 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 869 |
Descriptive statistics
| Standard deviation | 536.19731 |
|---|---|
| Coefficient of variation (CV) | 0.36319914 |
| Kurtosis | -0.37034272 |
| Mean | 1476.3177 |
| Median Absolute Deviation (MAD) | 415 |
| Skewness | -0.36477831 |
| Sum | 7.2867497 × 108 |
| Variance | 287507.56 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1007 | 566 | 0.1% |
| 1616 | 565 | 0.1% |
| 1640 | 556 | 0.1% |
| 1835 | 551 | 0.1% |
| 1610 | 550 | 0.1% |
| 1141 | 549 | 0.1% |
| 1834 | 547 | 0.1% |
| 1234 | 546 | 0.1% |
| 1153 | 545 | 0.1% |
| 1828 | 542 | 0.1% |
| Other values (1430) | 488059 | |
| (Missing) | 9173 | 1.8% |
| Value | Count | Frequency (%) |
| 1 | 320 | |
| 2 | 294 | |
| 3 | 269 | |
| 4 | 266 | |
| 5 | 290 | |
| 6 | 249 | |
| 7 | 231 | |
| 8 | 248 | |
| 9 | 243 | |
| 10 | 244 |
| Value | Count | Frequency (%) |
| 2400 | 296 | |
| 2359 | 338 | |
| 2358 | 325 | |
| 2357 | 330 | |
| 2356 | 307 | |
| 2355 | 341 | |
| 2354 | 340 | |
| 2353 | 366 | |
| 2352 | 347 | |
| 2351 | 367 |
ARR_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1136 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 10002 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1419877 |
| Minimum | -86 |
|---|---|
| Maximum | 2949 |
| Zeros | 9023 |
| Zeros (%) | 1.8% |
| Negative | 313591 |
| Negative (%) | 62.4% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | -86 |
|---|---|
| 5-th percentile | -29 |
| Q1 | -16 |
| median | -7 |
| Q3 | 8 |
| 95-th percentile | 67 |
| Maximum | 2949 |
| Range | 3035 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 55.133528 |
|---|---|
| Coefficient of variation (CV) | 13.310887 |
| Kurtosis | 263.97957 |
| Mean | 4.1419877 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 12.032413 |
| Sum | 2040952 |
| Variance | 3039.7059 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -11 | 13595 | 2.7% |
| -10 | 13575 | 2.7% |
| -12 | 13532 | 2.7% |
| -13 | 13414 | 2.7% |
| -9 | 13335 | 2.7% |
| -14 | 13075 | 2.6% |
| -8 | 12970 | 2.6% |
| -15 | 12940 | 2.6% |
| -7 | 12377 | 2.5% |
| -16 | 12313 | 2.4% |
| Other values (1126) | 361621 |
| Value | Count | Frequency (%) |
| -86 | 1 | < 0.1% |
| -76 | 1 | < 0.1% |
| -75 | 3 | |
| -74 | 3 | |
| -73 | 1 | < 0.1% |
| -72 | 3 | |
| -71 | 1 | < 0.1% |
| -70 | 3 | |
| -69 | 2 | |
| -68 | 3 |
| Value | Count | Frequency (%) |
| 2949 | 1 | |
| 2837 | 1 | |
| 2764 | 1 | |
| 2294 | 1 | |
| 2225 | 1 | |
| 2216 | 1 | |
| 2214 | 1 | |
| 2067 | 1 | |
| 2021 | 1 | |
| 2019 | 1 |
CANCELLED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
| 0.0 | |
|---|---|
| 1.0 | 9019 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1508247 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 493730 | |
| 1.0 | 9019 | 1.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 493730 | |
| 1.0 | 9019 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 996479 | |
| . | 502749 | |
| 1 | 9019 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 996479 | |
| . | 502749 | |
| 1 | 9019 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 996479 | |
| . | 502749 | |
| 1 | 9019 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 996479 | |
| . | 502749 | |
| 1 | 9019 | 0.6% |
CANCELLATION_CODE
Categorical
MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 493730 |
| Missing (%) | 98.2% |
| Memory size | 3.8 MiB |
| B | |
|---|---|
| A | |
| C | 274 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 9019 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| B | 7019 | 1.4% |
| A | 1726 | 0.3% |
| C | 274 | 0.1% |
| (Missing) | 493730 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 7019 | |
| a | 1726 | 19.1% |
| c | 274 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 7019 | |
| A | 1726 | 19.1% |
| C | 274 | 3.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9019 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 7019 | |
| A | 1726 | 19.1% |
| C | 274 | 3.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9019 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 7019 | |
| A | 1726 | 19.1% |
| C | 274 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9019 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 7019 | |
| A | 1726 | 19.1% |
| C | 274 | 3.0% |
DIVERTED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
| 0.0 | |
|---|---|
| 1.0 | 983 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1508247 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 501766 | |
| 1.0 | 983 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 501766 | |
| 1.0 | 983 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1004515 | |
| . | 502749 | |
| 1 | 983 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1004515 | |
| . | 502749 | |
| 1 | 983 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1004515 | |
| . | 502749 | |
| 1 | 983 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1508247 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1004515 | |
| . | 502749 | |
| 1 | 983 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING
| Distinct | 635 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 10002 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 115.3561 |
| Minimum | 8 |
|---|---|
| Maximum | 677 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 63 |
| median | 98 |
| Q3 | 145 |
| 95-th percentile | 269 |
| Maximum | 677 |
| Range | 669 |
| Interquartile range (IQR) | 82 |
Descriptive statistics
| Standard deviation | 71.58003 |
|---|---|
| Coefficient of variation (CV) | 0.62051359 |
| Kurtosis | 3.0183241 |
| Mean | 115.3561 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 1.5036401 |
| Sum | 56841374 |
| Variance | 5123.7007 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 60 | 4226 | 0.8% |
| 59 | 4221 | 0.8% |
| 63 | 4126 | 0.8% |
| 57 | 4109 | 0.8% |
| 58 | 4071 | 0.8% |
| 62 | 4068 | 0.8% |
| 65 | 4048 | 0.8% |
| 64 | 4047 | 0.8% |
| 61 | 3993 | 0.8% |
| 66 | 3990 | 0.8% |
| Other values (625) | 451848 | |
| (Missing) | 10002 | 2.0% |
| Value | Count | Frequency (%) |
| 8 | 4 | < 0.1% |
| 9 | 14 | < 0.1% |
| 10 | 14 | < 0.1% |
| 11 | 10 | < 0.1% |
| 12 | 6 | < 0.1% |
| 13 | 2 | < 0.1% |
| 14 | 10 | < 0.1% |
| 15 | 27 | < 0.1% |
| 16 | 65 | |
| 17 | 136 |
| Value | Count | Frequency (%) |
| 677 | 1 | |
| 670 | 1 | |
| 669 | 1 | |
| 667 | 1 | |
| 664 | 1 | |
| 662 | 1 | |
| 658 | 2 | |
| 657 | 1 | |
| 654 | 2 | |
| 653 | 1 |
CARRIER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 843 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 409780 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.731911 |
| Minimum | 0 |
|---|---|
| Maximum | 2947 |
| Zeros | 40359 |
| Zeros (%) | 8.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 24 |
| 95-th percentile | 102 |
| Maximum | 2947 |
| Range | 2947 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 78.885369 |
|---|---|
| Coefficient of variation (CV) | 3.0656631 |
| Kurtosis | 178.57557 |
| Mean | 25.731911 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 10.62912 |
| Sum | 2392270 |
| Variance | 6222.9014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 40359 | 8.0% |
| 15 | 1632 | 0.3% |
| 2 | 1606 | 0.3% |
| 1 | 1569 | 0.3% |
| 16 | 1555 | 0.3% |
| 3 | 1538 | 0.3% |
| 6 | 1515 | 0.3% |
| 4 | 1411 | 0.3% |
| 5 | 1403 | 0.3% |
| 17 | 1380 | 0.3% |
| Other values (833) | 39001 | 7.8% |
| (Missing) | 409780 |
| Value | Count | Frequency (%) |
| 0 | 40359 | |
| 1 | 1569 | 0.3% |
| 2 | 1606 | 0.3% |
| 3 | 1538 | 0.3% |
| 4 | 1411 | 0.3% |
| 5 | 1403 | 0.3% |
| 6 | 1515 | 0.3% |
| 7 | 1355 | 0.3% |
| 8 | 1362 | 0.3% |
| 9 | 1263 | 0.3% |
| Value | Count | Frequency (%) |
| 2947 | 1 | |
| 2827 | 1 | |
| 2705 | 1 | |
| 2294 | 1 | |
| 2216 | 1 | |
| 2214 | 1 | |
| 2018 | 1 | |
| 1974 | 1 | |
| 1809 | 1 | |
| 1805 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 436 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 409780 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9531887 |
| Minimum | 0 |
|---|---|
| Maximum | 1747 |
| Zeros | 88146 |
| Zeros (%) | 17.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 1747 |
| Range | 1747 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 38.743366 |
|---|---|
| Coefficient of variation (CV) | 9.8005355 |
| Kurtosis | 603.16718 |
| Mean | 3.9531887 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 21.733074 |
| Sum | 367524 |
| Variance | 1501.0484 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 88146 | 17.5% |
| 15 | 111 | < 0.1% |
| 16 | 109 | < 0.1% |
| 7 | 98 | < 0.1% |
| 17 | 95 | < 0.1% |
| 18 | 95 | < 0.1% |
| 6 | 88 | < 0.1% |
| 8 | 88 | < 0.1% |
| 23 | 85 | < 0.1% |
| 4 | 85 | < 0.1% |
| Other values (426) | 3969 | 0.8% |
| (Missing) | 409780 |
| Value | Count | Frequency (%) |
| 0 | 88146 | |
| 1 | 70 | < 0.1% |
| 2 | 74 | < 0.1% |
| 3 | 79 | < 0.1% |
| 4 | 85 | < 0.1% |
| 5 | 75 | < 0.1% |
| 6 | 88 | < 0.1% |
| 7 | 98 | < 0.1% |
| 8 | 88 | < 0.1% |
| 9 | 80 | < 0.1% |
| Value | Count | Frequency (%) |
| 1747 | 1 | < 0.1% |
| 1522 | 1 | < 0.1% |
| 1519 | 1 | < 0.1% |
| 1440 | 1 | < 0.1% |
| 1439 | 4 | |
| 1424 | 2 | |
| 1392 | 1 | < 0.1% |
| 1387 | 1 | < 0.1% |
| 1306 | 1 | < 0.1% |
| 1299 | 1 | < 0.1% |
NAS_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 304 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 409780 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.654939 |
| Minimum | 0 |
|---|---|
| Maximum | 1407 |
| Zeros | 47985 |
| Zeros (%) | 9.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 17 |
| 95-th percentile | 48 |
| Maximum | 1407 |
| Range | 1407 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 25.542698 |
|---|---|
| Coefficient of variation (CV) | 2.1915772 |
| Kurtosis | 382.26314 |
| Mean | 11.654939 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.987287 |
| Sum | 1083548 |
| Variance | 652.42944 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 47985 | 9.5% |
| 1 | 2261 | 0.4% |
| 15 | 1848 | 0.4% |
| 16 | 1732 | 0.3% |
| 2 | 1620 | 0.3% |
| 3 | 1595 | 0.3% |
| 17 | 1513 | 0.3% |
| 4 | 1445 | 0.3% |
| 5 | 1431 | 0.3% |
| 18 | 1377 | 0.3% |
| Other values (294) | 30162 | 6.0% |
| (Missing) | 409780 |
| Value | Count | Frequency (%) |
| 0 | 47985 | |
| 1 | 2261 | 0.4% |
| 2 | 1620 | 0.3% |
| 3 | 1595 | 0.3% |
| 4 | 1445 | 0.3% |
| 5 | 1431 | 0.3% |
| 6 | 1317 | 0.3% |
| 7 | 1252 | 0.2% |
| 8 | 1282 | 0.3% |
| 9 | 1072 | 0.2% |
| Value | Count | Frequency (%) |
| 1407 | 1 | |
| 1233 | 1 | |
| 1219 | 1 | |
| 1129 | 1 | |
| 1023 | 1 | |
| 875 | 1 | |
| 853 | 1 | |
| 838 | 1 | |
| 730 | 1 | |
| 716 | 2 |
SECURITY_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 86 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 409780 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15249169 |
| Minimum | 0 |
|---|---|
| Maximum | 1460 |
| Zeros | 92531 |
| Zeros (%) | 18.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1460 |
| Range | 1460 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.7494156 |
|---|---|
| Coefficient of variation (CV) | 44.260875 |
| Kurtosis | 29004.095 |
| Mean | 0.15249169 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 154.3624 |
| Sum | 14177 |
| Variance | 45.554612 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 92531 | 18.4% |
| 15 | 26 | < 0.1% |
| 12 | 19 | < 0.1% |
| 9 | 17 | < 0.1% |
| 8 | 16 | < 0.1% |
| 6 | 15 | < 0.1% |
| 18 | 15 | < 0.1% |
| 7 | 14 | < 0.1% |
| 14 | 14 | < 0.1% |
| 5 | 13 | < 0.1% |
| Other values (76) | 289 | 0.1% |
| (Missing) | 409780 |
| Value | Count | Frequency (%) |
| 0 | 92531 | |
| 1 | 13 | < 0.1% |
| 2 | 7 | < 0.1% |
| 3 | 10 | < 0.1% |
| 4 | 10 | < 0.1% |
| 5 | 13 | < 0.1% |
| 6 | 15 | < 0.1% |
| 7 | 14 | < 0.1% |
| 8 | 16 | < 0.1% |
| 9 | 17 | < 0.1% |
| Value | Count | Frequency (%) |
| 1460 | 1 | |
| 885 | 1 | |
| 808 | 1 | |
| 302 | 1 | |
| 224 | 1 | |
| 171 | 1 | |
| 144 | 1 | |
| 138 | 1 | |
| 125 | 1 | |
| 124 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 645 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 409780 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.616507 |
| Minimum | 0 |
|---|---|
| Maximum | 2225 |
| Zeros | 49855 |
| Zeros (%) | 9.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 27 |
| 95-th percentile | 110 |
| Maximum | 2225 |
| Range | 2225 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 60.737739 |
|---|---|
| Coefficient of variation (CV) | 2.4673582 |
| Kurtosis | 147.37893 |
| Mean | 24.616507 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.8912974 |
| Sum | 2288572 |
| Variance | 3689.073 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 49855 | 9.9% |
| 16 | 1089 | 0.2% |
| 15 | 1084 | 0.2% |
| 17 | 1012 | 0.2% |
| 18 | 928 | 0.2% |
| 21 | 873 | 0.2% |
| 19 | 866 | 0.2% |
| 20 | 861 | 0.2% |
| 23 | 785 | 0.2% |
| 14 | 770 | 0.2% |
| Other values (635) | 34846 | 6.9% |
| (Missing) | 409780 |
| Value | Count | Frequency (%) |
| 0 | 49855 | |
| 1 | 579 | 0.1% |
| 2 | 570 | 0.1% |
| 3 | 555 | 0.1% |
| 4 | 559 | 0.1% |
| 5 | 563 | 0.1% |
| 6 | 613 | 0.1% |
| 7 | 641 | 0.1% |
| 8 | 632 | 0.1% |
| 9 | 651 | 0.1% |
| Value | Count | Frequency (%) |
| 2225 | 1 | |
| 1784 | 1 | |
| 1780 | 1 | |
| 1715 | 1 | |
| 1650 | 1 | |
| 1630 | 1 | |
| 1584 | 1 | |
| 1564 | 1 | |
| 1527 | 1 | |
| 1518 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 2/6/2023 12:00:00 AM | 9E | 4629 | 12953 | LGA | New York, NY | New York | 22 | 10577 | BGM | Binghamton, NY | New York | 22 | 2105 | 2058.0 | -7.0 | 37.0 | 2.0 | 2211 | 2205.0 | -6.0 | 0.0 | NaN | 0.0 | 28.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 2/6/2023 12:00:00 AM | 9E | 4630 | 11433 | DTW | Detroit, MI | Michigan | 43 | 11977 | GRB | Green Bay, WI | Wisconsin | 45 | 1000 | 958.0 | -2.0 | 9.0 | 4.0 | 1048 | 1001.0 | -47.0 | 0.0 | NaN | 0.0 | 50.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 2/6/2023 12:00:00 AM | 9E | 4630 | 11977 | GRB | Green Bay, WI | Wisconsin | 45 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1133 | 1130.0 | -3.0 | 20.0 | 8.0 | 1354 | 1349.0 | -5.0 | 0.0 | NaN | 0.0 | 51.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 2/6/2023 12:00:00 AM | 9E | 4631 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 11641 | FAY | Fayetteville, NC | North Carolina | 36 | 1355 | 1352.0 | -3.0 | 9.0 | 4.0 | 1514 | 1456.0 | -18.0 | 0.0 | NaN | 0.0 | 51.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 2/6/2023 12:00:00 AM | 9E | 4631 | 11641 | FAY | Fayetteville, NC | North Carolina | 36 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 1600 | 1619.0 | 19.0 | 11.0 | 5.0 | 1739 | 1732.0 | -7.0 | 0.0 | NaN | 0.0 | 57.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 2/6/2023 12:00:00 AM | 9E | 4632 | 12478 | JFK | New York, NY | New York | 22 | 12397 | ITH | Ithaca/Cortland, NY | New York | 22 | 2200 | 2152.0 | -8.0 | 35.0 | 3.0 | 2312 | 2309.0 | -3.0 | 0.0 | NaN | 0.0 | 39.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 2/6/2023 12:00:00 AM | 9E | 4633 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 12953 | LGA | New York, NY | New York | 22 | 1015 | 1011.0 | -4.0 | 15.0 | 7.0 | 1156 | 1142.0 | -14.0 | 0.0 | NaN | 0.0 | 69.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 2/6/2023 12:00:00 AM | 9E | 4633 | 12953 | LGA | New York, NY | New York | 22 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 730 | 729.0 | -1.0 | 31.0 | 8.0 | 923 | 917.0 | -6.0 | 0.0 | NaN | 0.0 | 69.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 2/6/2023 12:00:00 AM | 9E | 4634 | 11193 | CVG | Cincinnati, OH | Kentucky | 52 | 11433 | DTW | Detroit, MI | Michigan | 43 | 620 | 640.0 | 20.0 | 28.0 | 7.0 | 741 | 759.0 | 18.0 | 0.0 | NaN | 0.0 | 44.0 | 0.0 | 18.0 | 0.0 | 0.0 | 0.0 |
| 9 | 1 | 2/6/2023 12:00:00 AM | 9E | 4635 | 10821 | BWI | Baltimore, MD | Maryland | 35 | 12478 | JFK | New York, NY | New York | 22 | 1702 | 1658.0 | -4.0 | 18.0 | 50.0 | 1845 | 1850.0 | 5.0 | 0.0 | NaN | 0.0 | 44.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 502739 | 7 | 2/26/2023 12:00:00 AM | YX | 5855 | 15016 | STL | St. Louis, MO | Missouri | 64 | 12953 | LGA | New York, NY | New York | 22 | 1829 | 1823.0 | -6.0 | 11.0 | 7.0 | 2159 | 2130.0 | -29.0 | 0.0 | NaN | 0.0 | 109.0 | NaN | NaN | NaN | NaN | NaN |
| 502740 | 7 | 2/26/2023 12:00:00 AM | YX | 5856 | 12953 | LGA | New York, NY | New York | 22 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 1100 | 1054.0 | -6.0 | 35.0 | 6.0 | 1238 | 1229.0 | -9.0 | 0.0 | NaN | 0.0 | 54.0 | NaN | NaN | NaN | NaN | NaN |
| 502741 | 7 | 2/26/2023 12:00:00 AM | YX | 5857 | 12953 | LGA | New York, NY | New York | 22 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 1700 | 1658.0 | -2.0 | 20.0 | 17.0 | 1857 | 1849.0 | -8.0 | 0.0 | NaN | 0.0 | 74.0 | NaN | NaN | NaN | NaN | NaN |
| 502742 | 7 | 2/26/2023 12:00:00 AM | YX | 5858 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1215 | 1210.0 | -5.0 | 21.0 | 5.0 | 1408 | 1408.0 | 0.0 | 0.0 | NaN | 0.0 | 92.0 | NaN | NaN | NaN | NaN | NaN |
| 502743 | 7 | 2/26/2023 12:00:00 AM | YX | 5859 | 14730 | SDF | Louisville, KY | Kentucky | 52 | 11433 | DTW | Detroit, MI | Michigan | 43 | 730 | 747.0 | 17.0 | 10.0 | 21.0 | 905 | 916.0 | 11.0 | 0.0 | NaN | 0.0 | 58.0 | NaN | NaN | NaN | NaN | NaN |
| 502744 | 7 | 2/26/2023 12:00:00 AM | YX | 5860 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 12953 | LGA | New York, NY | New York | 22 | 1000 | 954.0 | -6.0 | 14.0 | 11.0 | 1209 | 1146.0 | -23.0 | 0.0 | NaN | 0.0 | 87.0 | NaN | NaN | NaN | NaN | NaN |
| 502745 | 7 | 2/26/2023 12:00:00 AM | YX | 5861 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1010 | 1008.0 | -2.0 | 34.0 | 6.0 | 1206 | 1205.0 | -1.0 | 0.0 | NaN | 0.0 | 77.0 | NaN | NaN | NaN | NaN | NaN |
| 502746 | 7 | 2/26/2023 12:00:00 AM | YX | 5862 | 10785 | BTV | Burlington, VT | Vermont | 16 | 12953 | LGA | New York, NY | New York | 22 | 1105 | 1115.0 | 10.0 | 41.0 | 10.0 | 1233 | 1251.0 | 18.0 | 0.0 | NaN | 0.0 | 45.0 | 0.0 | 10.0 | 8.0 | 0.0 | 0.0 |
| 502747 | 7 | 2/26/2023 12:00:00 AM | YX | 5863 | 12953 | LGA | New York, NY | New York | 22 | 15016 | STL | St. Louis, MO | Missouri | 64 | 850 | 844.0 | -6.0 | 36.0 | 6.0 | 1110 | 1055.0 | -15.0 | 0.0 | NaN | 0.0 | 149.0 | NaN | NaN | NaN | NaN | NaN |
| 502748 | 7 | 2/26/2023 12:00:00 AM | YX | 5863 | 15016 | STL | St. Louis, MO | Missouri | 64 | 12953 | LGA | New York, NY | New York | 22 | 1203 | 1201.0 | -2.0 | 13.0 | 16.0 | 1529 | 1514.0 | -15.0 | 0.0 | NaN | 0.0 | 104.0 | NaN | NaN | NaN | NaN | NaN |